| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| RewardID (FK)(PK) | A token identifier for a Reward instance. | ID_RWD | Identity | integer | Reward(TR_RWD) |
| RewardDerivationSequenceNumber (PK) | A sequence number used to specify the order for applying derivation rules tied to a Reward. RewardDerivationSequenceNumber always starts with 1 and is incremented by 1 for each appended derivation step tied to the Reward. | AI_RWD_DRVN_SQN_NMB | LineNumber | integer | |
| MinimumQuantity | The minimum quantity of a reward item required to trigger this RewardDerivationRule. A value of 0 puts no lower bound on the minimum value. The default value for this attribute is 1. Buy 5 or more SKU 32343's and get a 6th for free. 5 is the minimum quantity of SKU 32343 units that must be purchased to trigger a 6th free item (17% discount). This only applies to INSTANT rewards not DEFERRABLE rewards. | QU_MNM_QTY | Quantity | DECIMAL(9,3) | |
| MaximumQuantity | The maximum quantity of a reward item that will result in the application of this RewardDerivationRule. A quantity higher than this value will not apply the rule. Example Buy 1 to 5 SKU 2312 and get a 5% discount. If the customer purchases a 6th SKU 2312 they will pay the full retail price since it exceeds the MaximumQuantity. | QU_MXM_QTY | Quantity | DECIMAL(9,3) | |
| RewardDerivationActionCode | RewardTransactionLevelActionCode Determines how a Reward is applied to a transaction, a transaction line item or a customer account. This code is related to the RewardDispositionCode. Within the scope of a Reward, the action code applies to the entire RetailTransaction. Within the scope of a RewardDerivationRule, the action code applies to one or a designated group of RetailTransactionLineItem instances within a RetailTransaction � but not the transaction as a whole. VALID VALUES: NEW_PRICE - base retail price is replaced by the RewardAmount value PCT_OFF - base retail price is reduced by the RewardAmount value which is a PERCENT AMT_OFF - base retail price is reduced by the RewardAmount which is a flat monetary value. EARN_REWARD_CURRENCY - Points, miles,or another retailer designated reward currency units are added to a customer account (note only applies if the customer has an account). REDEEM_REWARD_CURRENCY - Transforms the earned reward currency for the current transaction and, at the customers option, previously accrued reward currency balance into a discount that can be taken at a transaction or line item level | CD_RWD_ACTN | Code | varchar(20) | |
| MinimumItemTotalAmount | The minimum subtotal monetary value of sale return items matching this rule to trigger the reward derivation rule. Example: Buy $100 or more from DEPT 242 and get a 20% discount on those items. The $100 is the MininumItemTotalAmount which is required to trigger the 20% instant reward. | MO_MNM_ITM_TOT_AMT | Money | money | |
| RewardDerivationArgumentValue | The reward value (a monetary amount or percent) applied to a base retail to arrive at the value of the reward. | MO_RWD_ACTN_ARGMNT_VL | Money | money | |
| RewardArgumentQuantity | Specifies the total number of items that a RewardActionCode applies to. This number is part of the condition required to fire a given rule. Example If item A can be purchased 3 units for $10, the RewardActuionArgumentValue will be $10 and the RewardArgumentQuantity is 3. In this scenario the actual retail price is 3.34 for the first item, 3.33 for the second and third item A's In a scenario where Item A can be purchased as 3 units for $10 each, the RewardArgumentQuantity is 1. The total prices for three Item A's is $30. | QU_RWD_ARGMNT_QTY | Quantity | DECIMAL(9,3) | |
| ItemLevelExclusivityFlag | When this flag is TRUE, a deal has item matching rules which once applied (i.e. matched to a sale return item) cannot be used on any subsequent sale return line item in the transaction. It is a "use it once" rule. Example: We have two RewardDerivation rules (with attendant eligibility rules). They each have their ItemLevelExclusivityFlag values set to TRUE. Only one of the two rules may be used in a transaction Buy SKU 3879 and get a SKU 3879A attachment for free (limit 1 per customer) Buy SKU 3879 or SKU 4736 and take 50% off anything in Dept 232. In this example the firing of the first rule for SKU 3879 is exclusive and prevents the firing of the second rule. | FL_ITM_LV_EXCLSVTY | Flag | integer | |
| CustomerAccountValuationUnitTypeCode (FK) | A code that identifies a kind of valuation unit. Examples include: MONEY POINTS MILES GALLONS VISITS others that are relevant to a retailer | CD_CT_ACNT_VLN_UN_TYP | Code | varchar(20) | CustomerAccountValuationUnitType(CO_CT_ACNT_VLN_UN_TYP) |
| RewardDerivationLevelCode | A code that determines the scope of coverage for a given reward derivation where scope designates one of three levels: LINE_ITEM, TRANSACTION or ACCOUNT. This is different from the Reward.RewardAttributionLevelCode which determines the final reward output level where it is used and consumed. The RewardDerivationLevelCode identifies the level of information used as input to the calculation of a reward value. It is common to have different Reward.RewardAttributionLevelCode values and RewardDerivationLevelCode values. For example, a specific item SKU value may specifiy a 50 point bouns (a LINE_ITEM RewardDerivationCode) that will end up being added to a customer account balance (an ACCOUNT Reward.RewardAttributionLevelCode). Retailers routinely define derivation and eligibility rules at different levels from the reward attribution level. This is why ARTS carries two different kinds of reward level codes - one for derivation of the reward value and a separate one that tells what level that value applies to. The enumerated values that level code attributes may assume are the same set: LINE_ITEM, TRANSACTION and ACCOUNT. Valid values (from narrowest to widest scope): LINE_ITEM - reward derivation value is calculated based on the properties of a single SaleReturnLineItem. This includes item ID, item merchandise hierarchy (classification), item pre-reward retail value, item pre-reward cost value, brand and other attributes of a specific RetailTransactionLineItem. TRANSACTION - reward derivation value is calculated based on a property of the RetailTransaction. This may apply to channel (where an item is purchased), transaction subtotal (usually the total retail value of a retail transaction minus previously applied line item discounts), time of day, ACCOUNT - reward, when calculated is added to or subtracted from a customer account depending on the RewardDispositionCode. A RewardDispositionCode of 'INSTANT' means a reward is to be earned and redeemed in the current transaction and becomes a discount. A RewardDispositionCode of 'DEFERRABLE' means the reward may be added to a customer account balance for future redemption - and that makes it a CUSTOMER_ACCOUNT reward derivation level. | CD_RWD_DRVN_LV_CD | Code | varchar(20) | |
| MinMaxUnitTypeCode | A code that determines what kind of value the MinValue and MaxValue is quantifying. Valid values are: RTL_SL_UNIT - min or max retail selling units MONETARY - min or max monetary amount RWD_CURRENCY - min or max value refers to points, miles, meals or some other reward currency that is different from retail selling units and monetary value. | CD_MNM_MXM_TYP | Code | varchar(20) | |
| RewardDerivationRuleEligibilityID (FK) | A unique identifier for a Reward Derivation Rule Eligibility. | ID_EL_PRDV | Identity | integer | RewardEligibilityRule(CO_EL_PRDV) |